package JDBC;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCDemo9 {
    public static void main(String[] args) {
        Userinfo userinfo = InputUtil.getInputObject(new Userinfo(),"欢迎注册");

        try (Connection conn=DBUtil.getConnection();){
            String sql="INSERT INTO userinfo(username,password,nickname,age) " +
                    "VALUES (?,?,?,?) ";
            PreparedStatement ps=conn.prepareStatement(sql);
            ps.setString(1,userinfo.getUsername());
            ps.setString(2,userinfo.getPassword());
            ps.setString(3,userinfo.getNickname());
            ps.setInt(4,userinfo.getAge());

            int num=ps.executeUpdate();
            System.out.println(num>0?"注册成功":"注册失败");









        } catch (SQLException e) {
            throw new RuntimeException(e);
        }


    }
}
